Current Values by Group Report

Export Tools > CygNet Excel Export > Configuring a CygNet Excel Export Report > Configuring Data Values > Current Values by Group Report

Current Values by Group Report

The Current Values by Group report is based on points that belong to a group node (or sub node) and UDCs. The report retrieves a single value for each point. The value can be the point’s current value or a historical value.

Current Values by Group

To Set Up a Current Values by Group Report

Open CygNet Excel Export.
Click the Configure button
On the Values page, enable Current Values by Group. See a description for each report property below.

Select the GRP Site Service
Select the Root Node.
Optionally, select the Sub Node.

On the Tags page, select the UDCs.

Note: Optionally, to retrieve a historical value instead of a current value, double-click the Time cell for the item and enter the timestamp in the Value at Time box. The value closest to without exceeding the timestamp will be returned.

On the Columns page, select the point properties to be included in the report.
On the Format page, set the report format.
On the Export page, specify the name of the .csv file data will be written to and set the file extension option.
Click OK to exit the Setup box.
Click Get CygNet Data to run the report.
Save the file.

Report Properties

Property	Description
GRP Site Service	The name of the Group Service from which to retrieve the group information. Use … to select the service.
Root Node	The name of a Navigation Root Node. Use … to select the node.
Sub Node	The name of a sub node. Use … to select the sub-node. If blank, the report will include all sub nodes of the selected Root Node. Using this property, you can limit the report to a particular attribute value. For example, if the Root Node includes a "State" attribute, and one of the attribute values is "UT" (for Utah), if you specify UT as the Sub Node, the report will be limited to only points in the group for which the point’s facility has its State attribute as UT.

Property

Description

GRP Site Service

The name of the Group Service from which to retrieve the group information. Use … to select the service.

Root Node

The name of a Navigation Root Node. Use … to select the node.

Sub Node

The name of a sub node. Use … to select the sub-node.

If blank, the report will include all sub nodes of the selected Root Node. Using this property, you can limit the report to a particular attribute value. For example, if the Root Node includes a "State" attribute, and one of the attribute values is "UT" (for Utah), if you specify UT as the Sub Node, the report will be limited to only points in the group for which the point’s facility has its State attribute as UT.